Ryan Sides
Ryan Sides
-
Re: Automatic sorting of a column - workflow?
@Kash You can't sort via Workflows, but CAN do this through the API. If you have a developer friend they can set this up for you pretty quickly.1 · -
Re: Trying to include two bits of criteria from the same column in a COUNTIFS formula
@BethWork Hi Beth! In your formula above, the COUNTIFS is looking for all scenarios to be true in order to count it. So you're saying Range 5 should equal MA and it should also equal NY. IT can't equ…1 · -
Re: How to set a formula for 3 different values to prevent any duplication
Hi @Sameer you can check this sheet: https://app.smartsheet.com/b/publish?EQBCT=2acf94e49e11448a8277c246229c8fb4 Formulas used: Key column: =JOIN([Start Date]@row:Facilitator@row) Check column: =IF(C…1 · -
Re: Pie of pie chart in dashboard
@Joe Song Hey Joe, welcome to the community! You can't have it interactive like "click on this slice and the new pie shows up". But you could create two different pie charts and display bot…1 · -
Re: Cross sheet reference formula drag to other cells
@Dovy No dice. No way to update that cell reference that way. I've done something similar in excel before where I built the formulas there and copied them over as text into SS, but it was still clunk…1 ·
